--SELECT * FROM cat_recruiter
--DELETE FROM cat_recruiter
INSERT INTO cat_recruiter
SELECT
case len(convert(varchar(10),id))
    when 5 then '00000000-0000-0000-0000-0000000' + convert(varchar(10),id) 
    when 4 then '00000000-0000-0000-0000-00000000' + convert(varchar(10),id) 
    when 3 then '00000000-0000-0000-0000-000000000' + convert(varchar(10),id) 
    when 2 then '00000000-0000-0000-0000-0000000000' + convert(varchar(10),id) 
    when 1 then '00000000-0000-0000-0000-00000000000'+ convert(varchar(10),id) 
    end As Id,case len(convert(varchar(10),id))
    when 5 then '00000000-0000-0000-0000-0000000' + convert(varchar(10),id) 
    when 4 then '00000000-0000-0000-0000-00000000' + convert(varchar(10),id) 
    when 3 then '00000000-0000-0000-0000-000000000' + convert(varchar(10),id) 
    when 2 then '00000000-0000-0000-0000-0000000000' + convert(varchar(10),id) 
    when 1 then '00000000-0000-0000-0000-00000000000'+ convert(varchar(10),id) 
    end As Companyid,username AS [Username],userpwd AS [Password],NULL AS [PasswordSalt],ContactPer AS [Fullname],1 AS [IsAdmin],1 AS [Active],0 AS [Deleted],NULL AS [ExpiryDate],createddate AS [DateCreated],LastLoginDate AS [LastSignedIn]FROM srv_lnk.nchr2008.dbo.companyinfo
WHERE id in(select Id from companyinfo)

--SELECT TOP 10 * FROM srv_lnk.nchr2008.dbo.companyinfo